package com.yunchang.springboot.mapper.base;

import com.yunchang.springboot.models.base.FinanceShopSku;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface FinanceShopSkuMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(FinanceShopSku record);

    int insertSelective(FinanceShopSku record);

    FinanceShopSku selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(FinanceShopSku record);

    int updateByPrimaryKey(FinanceShopSku record);

    /**
     * 根据sku获取Category
     * @param sku
     * @return
     */
    String selectCategoryBySku(String sku);

    /**
     * 根据sku获得对应的店铺和区域以及sellerID
     * */
    FinanceShopSku getInfoBySku(@Param("sku")String sku);
}